<?php
//Zend_Loader::loadFile('../application/admin/models/Template.php');
class Hotel 
{
    /**
     * @var object Zend DB Adapter
     */
    private $_db;
    /**
     * @var string
     */
   
    public function __construct()
    {
			$this->_db = Zend_Registry::get('db');
    }
    
    public function listHotels()
    {
    	$getNewsletters = $this->_db->fetchAll("
			select* from hotels
			
		");
		
		return $getNewsletters;
	}
	

    public function getHotel($hotel_id)
    {
    	//echo $hotel_id;exit;
    $sql="
			select hotel_id,hotel_title,hotel_city,hotel_country,hotel_description,
    	 hotel_contactperson,hotel_phone,hotel_fax,hotel_skype,is_Enabled
			from  hotels where   hotel_id='".$hotel_id."'
			
		";
  // echo $sql;exit;
    	$getHotel = $this->_db->fetchrow($sql);
	//	print_r($getHotel);exit;
		return $getHotel;
       
    }

    

}

